LogOffServer Method (Application Object)

The LogOffServer method logs off an SQL server or ODBC data source. Use this method when you have logged on to the data source by using LogOnServer Method (Application Object).

Syntax

object.LogOffServer DLLName, ServerName, DatabaseName, UserID, Password

Parameters

DLLName

Specifies the name of the DLL for the server or password-protected non-SQL table that you want to log on to (for example, "PDSODBC.DLL"). Note that the DLLName must be enclosed in quotes. DLL names have the following naming convention: PDB*.DLL for standard (non-SQL) databases, PDS*.DLL for SQL/ODBC databases.

ServerName

Specifies the logon name for the server used to create the report.* (For ODBC, use the data source name.) This value is case-sensitive.

DatabaseName (Optional)

Specifies the name for the database used to create the report.*

UserID (Optional)

Specifies the User ID number necessary to log on to the server.*

Password (Optional)

Specifies the password necessary to log on to the server.

*When you pass an empty string ("") for this parameter, the program uses the value that is already set in the report. If you want to override a value that is already set in the report, use a non-empty string (for example, "Server A").

Remarks

If you try to log off a server that is still in use (that is, there is an object variable still in focus that holds reference to a report that requires being logged on to the server to access data) you will be unable to log off. This will apply to every object that comes from the Report Object, as they all hold reference to the report through their respective Report properties.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com